package com.aaa.dao;
import org.apache.ibatis.annotations.Select;
import java.util.List;
import java.util.Map;

/**
 * @Author: TT
 * @Date: 2019/3/28 20:51
 * @Version 1.0
 */
public interface T_KnowledgeDao {
    @Select("<script>SELECT r.`name`,r.SHtime,s.average1,e.exam_name FROM exam e,exam_scorce s,regist r " +
            "WHERE e.id=s.exam_id AND e.information_id=r.id <if test=\"name!=null and name!=''\"> and r.`name`=#{name} </if>  limit #{start},#{pageSize} </script>")
    List<Map> selectAll(Map map);


    @Select("<script> SELECT COUNT(r.`name`) FROM exam e,exam_scorce s,regist r " +
            "WHERE e.id=s.exam_id AND e.information_id=r.id <if test=\"name!=null and name!=''\"> and r.`name`=#{name} </if>  limit #{start},#{pageSize} </script>")
    Integer getCount(Map map);
}
